Skip Headers

Oracle® Database Application Developer's Guide - Workspace Manager 10g Release 2 (10.2) Part Number B14253-01 |
Home | Book List | Contents | Master Index | Feedback

Previous
| View PDF

# Index

A B C D E F G H I J L M N O P R S T U V W

## Symbols

  _LT tables
    created for Workspace Manager infrastructure, 1.1.11
    getting name of, 4

## A

  ACCESS_ANY_WORKSPACE privilege, 1.4
  ACCESS_WORKSPACE privilege, 1.4
  Add_Topo_Geometry_Layer procedure, 4
  AddAsParentWorkspace procedure, 4
  Advanced Queueing
    and Workspace Manager events, 2
  ALL_MP_GRAPH_WORKSPACES view, 5.1
  ALL_MP_PARENT_WORKSPACES view, 5.2
  ALL_VERSION_HVIEW view, 5.3
  ALL_WM_CONS_COLUMNS view, 5.4
  ALL_WM_CONSTRAINTS view, 5.5
  ALL_WM_IND_COLUMNS view, 5.6
  ALL_WM_IND_EXPRESSIONS view, 5.7
  ALL_WM_LOCKED_TABLES view, 5.8
  ALL_WM_MODIFIED_TABLES view, 5.9
  ALL_WM_RIC_INFO view, 5.10
  ALL_WM_TAB_TRIGGERS view, 5.11
  ALL_WM_VERSIONED_TABLES view, 5.12
  ALL_WM_VT_ERRORS view, 5.13
  ALL_WORKSPACE_PRIVS view, 5.14
  ALL_WORKSPACE_SAVEPOINTS view, 5.15
  ALL_WORKSPACES view, 5.16
  ALLOW_CAPTURE_EVENTS system parameter, 1.5, 2.3
  ALLOW_MULTI_PARENT_WORKSPACES system parameter, 1.5
  ALLOW_NESTED_TABLE_COLUMNS system parameter, 1.5
  altering
    savepoint description, 4
    version-enabled table to add valid time support, 4
    workspace description, 4
  AlterSavepoint procedure, 4
  AlterVersionedTable procedure, 4
  AlterWorkspace procedure, 4
  asynchronous notification for Workspace Manager events, 2.4.5
  auditing modifications
    EnableVersioning history option, 4
    history views (xxx_HIST), 5.44
  auto_commit parameter, 1.1.8
  autocommitting of operations, 1.1.8

## B

  BeginBulkLoading procedure, 4
  BeginDDL procedure, 4
  BeginResolve procedure, 4
  bulk loading, 1.7
    BeginBulkLoading procedure, 4
    EndBulkLoading procedure, 4
    RollbackBulkLoading procedure, 4

## C

  ChangeWorkspaceType procedure, 4
  child workspace, 1.1.1
    as alternative to creating savepoint, 1.1.2.1
    merging, 4
    refreshing, 4, 4
    removing, 4
  CommitDDL procedure, 4
  CommitResolve procedure, 4
  compressing
    workspaces, 4, 4
  compression
    NUMBER_OF_COMPRESS_BATCHES system parameter, 1.5
  compression (Workspace Manager)
    SetCompressWorkspace procedure, 4
    WM_COMPRESS_BATCH_SIZES view, 5.37
    WM_COMPRESSIBLE_TABLES view, 5.38
  CompressWorkspace procedure, 4
  CompressWorkspaceTree procedure, 4
  conflict management, 1.16.6, 4
    beginning resolution, 4
    committing resolution, 4
    rolling back resolution, 4
    showing conflicts, 4
  conflict resolution
    example, 5.42
  conflict views (xxx_CONF), 5.42
  constraints
    maximum name length for Workspace Manager, 1.1.11
    support with Workspace Manager, 1.9
  context (session), 1.2
    GetSessionInfo function, 4
  context of current operation
    getting, 4
  continually refreshed workspaces, 1.1.9
    changing workspace type, 4
    CR_WORKSPACE_MODE system parameter, 1.5
    creating, 4
  CopyForUpdate procedure, 4
  CR_WORKSPACE_MODE system parameter, 1.5
  CREATE_ANY_WORKSPACE privilege, 1.4
  CREATE_WORKSPACE privilege, 1.4
  CreateSavepoint procedure, 4
  CreateWorkspace procedure, 4
  creating
    savepoints, 4
    workspaces, 4

## D

  DBA_WM_SYS_PRIVS view, 5.17
  DBA_WM_VT_ERRORS view, 5.18
  DBA_WORKSPACE_SESSIONS view, 5.19
  DBMS_WM package, 1.1.12
    Add_Topo_Geometry_Layer, 4
    AddAsParentWorkspace, 4
    AlterSavepoint, 4
    AlterVersionedTable, 4
    AlterWorkspace, 4
    BeginBulkLoading, 4
    BeginDDL, 4
    BeginResolve, 4
    ChangeWorkspaceType, 4
    CommitDDL, 4
    CommitResolve, 4
    CompressWorkspace, 4
    CompressWorkspaceTree, 4
    CopyForUpdate, 4
    CreateSavepoint, 4
    CreateWorkspace, 4
    Delete_Topo_Geometry_Layer, 4
    DeleteSavepoint, 4
    DisableVersioning, 4
    DropReplicationSupport, 4
    EnableVersioning, 4
    EndBulkLoading, 4
    Export, 4
    FindRICSet, 4
    FreezeWorkspace, 4
    GenerateReplicationSupport, 4
    GetBulkLoadVersion, 4
    GetConflictWorkspace, 4
    GetDiffVersions, 4
    GetLockMode, 4
    GetMultiWorkspaces, 4
    GetOpContext, 4
    GetPhysicalTableName, 4
    GetPrivs, 4
    GetSessionInfo, 4
    GetSystemParameter, 4
    GetValidFrom, 4
    GetValidTill, 4
    GetWMMetadataSpace, 4
    GetWorkspace, 4
    GotoWorkspace, 4
    GrantGraphPriv, 4
    GrantSystemPriv, 4
    GrantWorkspacePriv, 4
    Import, 4
    IsWorkspaceOccupied, 4
    LockRows, 4
    MergeTable, 4
    MergeWorkspace, 4
    Move_Proc, 4
    RecoverAllMigratingTables, 4
    RecoverFromDroppedUser, 4
    RecoverMigratingTable, 4
    RefreshTable, 4
    RefreshWorkspace, 4
    RelocateWriterSite, 4
    RemoveAsParentWorkspace, 4
    RemoveWorkspace, 4
    RemoveWorkspaceTree, 4
    ResolveConflicts, 4
    RevokeGraphPriv, 4
    RevokeSystemPriv, 4
    RevokeWorkspacePriv, 4
    RollbackBulkLoading, 4
    RollbackDDL, 4
    RollbackResolve, 4
    RollbackTable, 4
    RollbackToSP, 4
    RollbackWorkspace, 4
    SetCaptureEvent, 4
    SetCompressWorkspace, 4
    SetConflictWorkspace, 4
    SetDiffVersions, 4
    SetLockingOFF, 4
    SetLockingON, 4
    SetMultiWorkspaces, 4
    SetSystemParameter, 4
    SetTriggerEvents, 4
    SetValidTime, 4
    SetWMValidTimeFilterOFF, 4
    SetWMValidTimeFilterON, 4
    SetWMValidUpdateModeOFF, 4
    SetWMValidUpdateModeON, 4
    SetWoOverwriteOFF, 4
    SetWoOverwriteON, 4
    SetWorkspaceLockModeOFF, 4
    SetWorkspaceLockModeON, 4
    SynchronizeSite, 4
    UnfreezeWorkspace, 4
    UnlockRows, 4
    UseDefaultValuesForNulls, 4
  DBMS_WM public synonym, 4
  DDL (data definition language) operations
    requirements and restrictions, 1.8
  Delete_Topo_Geometry_Layer procedure, 4
  DeleteSavepoint procedure, 4
  deleting
    savepoints, 4
    workspace, 1.1.6, 4
  difference views (xxx_DIFF), 5.43
  DisableVersioning procedure, 4
  disabling
    workspace changes, 4
  downgrading to another Workspace Manager release, B
  DropReplicationSupport procedure, 4

## E

  effective dating
    See valid time support
  EnableVersioning procedure, 4
  EndBulkLoading procedure, 4
  event parameters, 2.2
  events (Workspace Manager), 2
    ALLOW_CAPTURE_EVENTS system parameter, 1.5, 2.3
    asynchronous notification, 2.4.5
    capturing, 4
    event parameters, 2.2
    list of events, 2.1
    listening for, 2.4.4
    WM_EVENTS_INFO view, 5.39
  example
    conflict resolution, 5.42
    using Workspace Manager (Oracle sample schemas), 1.17.2
  exclusive locks, 1.3, 4
  explicit savepoints, 1.1.2
  export considerations, 1.6
  Export procedure, 4

## F

  FindRICSet procedure, 4
  FIRE_TRIGGERS_FOR_NONDML_EVENTS system parameter, 1.5
  foreign keys with version-enabled tables, 1.9.1
  FREEZE_ANY_WORKSPACE privilege, 1.4
  FREEZE_WORKSPACE privilege, 1.4
  FreezeWorkspace procedure, 4
  freezing
    workspace changes, 1.1.5, 4

## G

  GenerateReplicationSupport procedure, 4
  GetBulkLoadVersion function, 4
  GetConflictWorkspace function, 4
  GetDiffVersions function, 4
  GetLockMode function, 4
  GetMultiWorkspaces function, 4
  GetOpContext function, 4
  GetPhysicalTableName function, 4
  GetPrivs function, 4
  GetSessionInfo procedure, 4
  GetSystemParameter function, 4
  GetValidFrom function, 4
  GetValidTill function, 4
  GetWMMetadataSpace function, 4
  GetWorkspace function, 4
  GotoWorkspace procedure, 4
  grant option, 1.4
  GrantGraphPriv procedure, 4
  granting
    Workspace Manager privileges
      multiparent graph workspaces, 4
      system, 4
      workspace, 4
  GrantSystemPriv procedure, 4
  GrantWorkspacePriv procedure, 4

## H

  hierarchy
    removing, 4
    workspaces, 1.1.1
  history columns
    upgrading, B.3
  history management changes for release 10.1, B.3
  history option
    EnableVersioning procedure, 4
  history views (xxx_HIST), 5.44

## I

  implicit savepoints, 1.1.2
  import considerations, 1.6
  Import procedure, 4
  infrastructure for version-enabling of tables, 1.1.11
  IsWorkspaceOccupied function, 4

## J

  join index
    cannot be created or dropped on version-enabled table, 1.8

## L

  LATEST savepoint, 1.1.2
  length of object names
    maximums for Workspace Manager, 1.1.11
  LIVE workspace, 1.1.1
  LOB columns with versioned tables, 4
  lock management, 1.3, 1.16.5
  lock mode
    getting, 4
  lock views (xxx_LOCK), 5.45
  locking mode
    optimistic, 1.5, 1.5
    pessimistic, 1.5, 1.5
  locking table rows, 4
  LockRows procedure, 4
  locks
    disabling, 4
    enabling, 4
    exclusive, 1.3
    shared, 1.3
    version-exclusive, 1.3
    workspace-exclusive, 1.3
  logging of modifications
    EnableVersioning history option, 4
    history views (xxx_HIST), 5.44
  long transactions, 1
  LT tables
    created for Workspace Manager infrastructure, 1.1.11
    getting name of _LT (physical) table, 4

## M

  materialized views
    version management with, 1.13
  MERGE_ANY_WORKSPACE privilege, 1.4
  MERGE_WORKSPACE privilege, 1.4
  MergeTable procedure, 4
  MergeWorkspace procedure, 4
  merging
    table changes, 4
    workspaces, 1.1.3, 4
  metadata space
    getting, 4
  migrating to another Workspace Manager release, B
  Move_Proc procedure, 4
  multilevel referential integrity constraints, 1.9.1
  multiparent workspaces, 1.1.10
    ALLOW_MULTI_PARENT_WORKSPACES system parameter, 1.5
  multiworkspace views (xxx_MW), 5.46

## N

  name length of database objects
    maximums for Workspace Manager, 1.1.11
  nested table columns
    ALLOW_NESTED_TABLE_COLUMNS system parameter, 1.5
  NONCR_WORKSPACE_MODE system parameter, 1.5
  nonsequenced update operations, 3.6.2.1
  nonwriter sites, C
  null values
    using default values for, 4
  NUMBER_OF_COMPRESS_BATCHES system parameter, 1.5

## O

  OE.WAREHOUSES table
    Workspace Manager example, 1.17.2
  operation context
    getting, 4
  operators for valid time support, 3.5
    WM_CONTAINS, 3.5.1
    WM_EQUALS, 3.5.2
    WM_GREATERTHAN, 3.5.3
    WM_INTERSECTION, 3.5.4
    WM_LDIFF, 3.5.5
    WM_LESSTHAN, 3.5.6
    WM_MEETS, 3.5.7
    WM_OVERLAPS, 3.5.8
    WM_RDIFF, 3.5.9
  optimistic locking, 1.5, 1.5
  Oracle sample schemas
    Workspace Manager example, 1.17.2
  OWM_VERSION
    Workspace Manager version number, 5.40

## P

  parent workspace, 1.1.1
    conflicts with, 4
  partitioned index
    cannot be created or dropped on version-enabled table, 1.8
  pessimistic locking, 1.5, 1.5
  physical table name
    and Workspace Manager infrastructure, 1.1.11
    getting, 4
  privilege management, 1.16.4
  privileges
    ACCESS_ANY_WORKSPACE, 1.4
    ACCESS_WORKSPACE, 1.4
    CREATE_ANY_WORKSPACE, 1.4
    CREATE_WORKSPACE, 1.4
    description, 1.4
    FREEZE_ANY_WORKSPACE, 1.4
    FREEZE_WORKSPACE, 1.4
    getting, 4
    grant option, 1.4
    granted to PUBLIC user group, 1.1.12
    granting, 4, 4
      multiparent graph workspaces, 4
    managing, 1.4
    MERGE_ANY_WORKSPACE, 1.4
    MERGE_WORKSPACE, 1.4
    REMOVE_ANY_WORKSPACE, 1.4
    REMOVE_WORKSPACE, 1.4
    revoking, 1.4, 4, 4
      multiparent graph workspaces, 4
    ROLLBACK_ANY_WORKSPACE, 1.4
    ROLLBACK_WORKSPACE, 1.4
    viewing users having Workspace Manager system-level privileges, 5.17

## R

  RecoverAllMigratingTables procedure, 4
  RecoverFromDroppedUser procedure, 4
  RecoverMigratingTable procedure, 4
  referential integrity constraints
    finding affected tables, 4
  referential integrity support, 1.9.1
    multilevel constraints, 1.9.1
  refreshing
    workspaces, 4
  refreshing tables, 4
  RefreshTable procedure, 4
  RefreshWorkspace procedure, 4
  RelocateWriterSite procedure, 4
  removable savepoints, 1.1.2
  REMOVE_ANY_WORKSPACE privilege, 1.4
  REMOVE_WORKSPACE privilege, 1.4
  RemoveAsParentWorkspace procedure, 4
  RemoveWorkspace procedure, 4
  RemoveWorkspaceTree procedure, 4
  removing workspaces, 1.1.6, 4
  replication
    dropping support for, 4
    generating support for, 4
    relocating writer site, 4
    synchronizing local site, 4
    using with Workspace Manager, C
    WM_REPLICATION_INFO view, 5.41
    writer and nonwriter sites, C
  reserved words and characters with Workspace Manager, 1.15
  ResolveConflicts procedure, 4
  resolving conflicts, 4
    beginning, 4
    committing, 4
    rolling back, 4
  RETURNING clause
    not supported for INSERT or UPDATE on version-enabled tables, 1.1.11
  reverse index
    cannot be created or dropped on version-enabled table, 1.8
  RevokeGraphPriv procedure, 4
  RevokeSystemPriv procedure, 4
  RevokeWorkspacePriv procedure, 4
  revoking privileges, 1.4, 4, 4
    multiparent graph workspaces, 4
  ROLE_WM_PRIVS view, 5.20
  ROLLBACK_ANY_WORKSPACE privilege, 1.4
  ROLLBACK_WORKSPACE privilege, 1.4
  RollbackBulkLoading procedure, 4
  RollbackDDL procedure, 4
  RollbackResolve procedure, 4
  RollbackTable procedure, 4
  RollbackToSP procedure, 4
  RollbackWorkspace procedure, 4
  rolling back
    changes in a table, 4
    workspace changes, 1.1.3, 4
    workspaces to savepoint, 4
  row-level security (VPD)
    Workspace Manager considerations, 1.11
  rows
    locking, 4
    unlocking, 4
  rule-based subscription for Workspace Manager events, 2.4.3

## S

  sample schemas
    Workspace Manager example, 1.17.2
  savepoint management, 1.16.3
  savepoints, 1.1
    altering description of, 4
    as alternative to creating child workspaces, 1.1.2.1
    creating, 4
    deleting, 4
    explicit, 1.1.2
    implicit, 1.1.2
    removable, 1.1.2
    rolling back to, 4
  sequenced delete operations, 3.6.2.1
    disabling, 4
    enabling, 4
  sequenced update operations, 3.6.2.1
    disabling, 4
    enabling, 4
  session context, 1.2
    GetSessionInfo function, 4
  SetCaptureEvent procedure, 4
  SetCompressWorkspace procedure, 4
  SetConflictWorkspace procedure, 4
  SetDiffVersions procedure, 4
  SetLockingOFF procedure, 4
  SetLockingON procedure, 4
  SetMultiWorkspaces procedure, 4
  SetSystemParameter procedure, 4
  SetTriggerEvents procedure, 4
  SetValidTime procedure, 4
  SetWMValidTimeFilterOFF procedure, 4
  SetWMValidTimeFilterON procedure, 4
  SetWMValidUpdateModeOFF procedure, 4
  SetWMValidUpdateModeON procedure, 4
  SetWoOverwriteOFF procedure, 4
  SetWoOverwriteON procedure, 4
  SetWorkspaceLockModeOFF procedure, 4
  SetWorkspaceLockModeON procedure, 4
  shared locks, 1.3, 4
  skeleton tables, 1.8
  spatial topologies
    version management with, 1.14
  subscription (rule-based) for Workspace Manager events, 2.4.3
  SynchronizeSite procedure, 4
  synonyms
    support for, 1.12
  SYS.OWM_PKG.UpgradeHistoryColumns procedure, B.3
  system parameters
    ALLOW_CAPTURE_EVENTS, 1.5
    ALLOW_MULTI_PARENT_WORKSPACES, 1.5
    ALLOW_NESTED_TABLE_COLUMNS, 1.5
    CR_WORKSPACE_MODE, 1.5
    FIRE_TRIGGERS_FOR_NONDML_EVENTS, 1.5
    for Workspace Manager, 1.5
    NONCR_WORKSPACE_MODE, 1.5
    NUMBER_OF_COMPRESS_BATCHES, 1.5
    shown in WM_INSTALLATION view, 5.40
    UNDO_SPACE, 1.5
    USE_TIMESTAMP_TYPE_FOR_HISTORY, 1.5
  system privileges, 4
    viewing users having Workspace Manager system-level privileges, 5.17

## T

  table management, 1.16.1
  table name
    and Workspace Manager infrastructure, 1.1.11
    getting physical table name, 4
    maximum length for Workspace Manager, 1.1.11
  table synonyms, 1.12
  time zone
    support with Workspace Manager, B.3
  timestamp with time zone
    support with Workspace Manager, B.3
  topologies
    version management with, 1.14
  topology geometry layer
    adding, 4
    deleting, 4
  trigger events
    setting, 4
  triggers on version-enabled tables, 1.10

## U

  UNDO_SPACE system parameter, 1.5
  UnfreezeWorkspace procedure, 4
  unfreezing
    workspaces, 1.1.5, 4
  unique constraints
    support with Workspace Manager, 1.9.2
  unlocking
    table rows, 4
  UnlockRows procedure, 4
  UpgradeHistoryColumns procedure, B.3
  upgrading to another Workspace Manager release, B
  USE_TIMESTAMP_TYPE_FOR_HISTORY system parameter, 1.5
  UseDefaultValuesForNulls procedure, 4
  USER_MP_GRAPH_WORKSPACES view, 5.21
  USER_MP_PARENT_WORKSPACES view, 5.22
  USER_WM_CONS_COLUMNS view, 5.23
  USER_WM_CONSTRAINTS view, 5.24
  USER_WM_IND_COLUMNS view, 5.25
  USER_WM_IND_EXPRESSIONS view, 5.26
  USER_WM_LOCKED_TABLES view, 5.27
  USER_WM_MODIFIED_TABLES view, 5.28
  USER_WM_PRIVS view, 5.29
  USER_WM_RIC_INFO view, 5.30
  USER_WM_TAB_TRIGGERS view, 5.31
  USER_WM_VERSIONED_TABLES view, 5.32
  USER_WM_VT_ERRORS view, 5.33
  USER_WORKSPACE_PRIVS view, 5.34
  USER_WORKSPACE_SAVEPOINTS view, 5.35
  USER_WORKSPACES view, 5.36

## V

  valid time filter
    removing, 4
    setting, 4
  valid time support, 3
    altering version-enabled table to add valid time support, 4
    operators, 3.5
    setting valid time for session, 4
  version number
    Workspace Manager (OWM_VERSION), 5.40
  version-enabled tables
    definition, 1.1
    maximum name length for Workspace Manager, 1.1.11
  version-exclusive locks, 1.3
  versioning
    disabling, 4
    enabling, 4
    infrastructure created for, 1.1.11
  VIEW_WO_OVERWRITE mode
    disabling, 4
    enabling, 4
  virtual private databases
    with Workspace Manager, 1.11
  VPD (virtual private database)
    with Workspace Manager, 1.11

## W

  WM_ADMIN_ROLE role, 1.4
  WM_COMPRESS_BATCH_SIZES view, 5.37
  WM_COMPRESSIBLE_TABLES view, 5.38
  WM_CONTAINS operator, 3.5.1
  WM_EQUALS operator, 3.5.2
  WM_EVENTS_INFO view, 5.39
  WM_GREATERTHAN operator, 3.5.3
  WM_INSTALLATION view, 5.40
  WM_INTERSECTION operator, 3.5.4
  WM_LDIFF operator, 3.5.5
  WM_LESSTHAN operator, 3.5.6
  WM_MEETS operator, 3.5.7
  WM_OVERLAPS operator, 3.5.8
  WM_RDIFF operator, 3.5.9
  WM_REPLICATION_INFO view, 5.41
  WMSYS schema and user, 1.1.12
  workspace lock mode
    disabling, 4
    enabling, 4
  Workspace Manager metadata space
    getting, 4
  workspace-exclusive locks, 1.3
  workspaces
    altering description of, 4
    changing type, 4
    child
      as alternative to creating savepoints, 1.1.2.1
    compressing, 4, 4
    continually refreshed, 1.1.9, 4, 4
      CR_WORKSPACE_MODE system parameter, 1.5
    creating, 4
    freezing, 1.1.5, 4
    getting, 4
    going to, 4
    hierarchy, 1.1.1
    management of, 1.1, 1.16.2
    merging, 1.1.3
    multiparent, 1.1.10
      ALLOW_MULTI_PARENT_WORKSPACES system parameter, 1.5
    rolling back, 1.1.3
    unfreezing, 1.1.5, 4
  writer site, C